/*
 Navicat Premium Data Transfer

 Source Server         : LKFX
 Source Server Type    : SQLite
 Source Server Version : 3008004
 Source Database       : main

 Target Server Type    : SQLite
 Target Server Version : 3008004
 File Encoding         : utf-8

 Date: 11/08/2016 14:42:02 PM
*/

PRAGMA foreign_keys = false;

-- ----------------------------
--  Table structure for tArrearage
-- ----------------------------
DROP TABLE IF EXISTS "tArrearage";
CREATE TABLE "tArrearage" (
    "aId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "aOrderNo" text,
    "aCoNo" text,
    "aArreaMoney" real,
    "aBusinessmanNo" text,
    "aBusinessman" text,
    "aArreaReason" text,
    "aCreateUserNo" text,
    "aCreateUserName" text,
    "aCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "aRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tArrearage", '1');

-- ----------------------------
--  Records of tArrearage
-- ----------------------------
BEGIN;
INSERT INTO "tArrearage" VALUES (1, 2016010100001, 'commodity00001', 5000.0, 'JSJ001', '佳乐家001', '购买了金锣火腿肠', 'gcx', 'gcx', '', 'remark');
COMMIT;

-- ----------------------------
--  Table structure for tCommodityCategory
-- ----------------------------
DROP TABLE IF EXISTS "tCommodityCategory";
CREATE TABLE "tCommodityCategory" (
    "caId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "caFirstType" text,
    "caSecondType" text,
    "caThirdType" text,
    "caFourthType" text,
    "caFifthType" text,
    "caWarehouseNo" text,
    "caWarehouse" text,
    "caCreateUserNo" text,
    "caCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "caRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tCommodityCategory", '2');

-- ----------------------------
--  Records of tCommodityCategory
-- ----------------------------
BEGIN;
INSERT INTO "tCommodityCategory" VALUES (1, '食品', '金锣', '金锣王10*50g', null, null, 'CK001', '仓库001', 'gcx', '2016-11-08 10:35:58', '');
INSERT INTO "tCommodityCategory" VALUES (2, '食品', '旺旺', '旺旺雪饼10*15g', null, null, 'CK001', '仓库001', 'gcx', '2016-11-08 14:41:03', null);
COMMIT;

-- ----------------------------
--  Table structure for tCommodityInfo
-- ----------------------------
DROP TABLE IF EXISTS "tCommodityInfo";
CREATE TABLE "tCommodityInfo" (
	 "cId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	 "cCoNo" text NOT NULL,
	 "cName" text,
	 "cCategory" text,
	 "cUnit" text,
	 "cUnitConversion" text,
     "cPriceType" text,
	 "cPrice" text,
	 "cCreateUserNo" text,
	 "cCreateTime" text DEFAULT (datetime('now', 'localtime')),
	 "cRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tCommodityInfo", '2');

-- ----------------------------
--  Records of tCommodityInfo
-- ----------------------------
BEGIN;
INSERT INTO "tCommodityInfo" VALUES (1, 'commodity00001', '金锣王10*50g', '食品,金锣,金锣王10*50g', '箱,包', '*50,*1', '标准价', '450.00,9.00', 'gcx', '', '');
INSERT INTO "tCommodityInfo" VALUES (2, 'commodity00002', '旺旺雪饼10*15g', '食品,旺旺,旺旺雪饼10*15g', '箱,袋', '*20,*1', '标准价', '100.00,5.00', 'gcx', '2016-11-08 14:17:41', null);
COMMIT;

-- ----------------------------
--  Table structure for tGatheringDay
-- ----------------------------
DROP TABLE IF EXISTS "tGatheringDay";
CREATE TABLE "tGatheringDay" (
    "gId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "gOrderNo" text,
    "gOrderType" integer,
    "gCoNo" text,
    "gBusinessmanNo" text,
    "gBusinessman" text,
    "gGatheringTime" text,
    "gGatheringReason" text,
    "gCreateUserNo" text,
    "gCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "gRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tGatheringDay", '1');

-- ----------------------------
--  Records of tGatheringDay
-- ----------------------------
BEGIN;
INSERT INTO "tGatheringDay" VALUES (1, 2016010100001, 1, 'commodity00001', 'JSJ001', '佳乐家001', '2015-02-02 12:00:02', '收款', 'gcx', '', '');
COMMIT;

-- ----------------------------
--  Table structure for tInventoryInfo
-- ----------------------------
DROP TABLE IF EXISTS "tInventoryInfo";
CREATE TABLE "tInventoryInfo" (
    "iId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "iCoNo" text,
    "iUnit" TEXT,
    "iInventoryCount" text,
    "iCreateUserNo" TEXT,
    "iCreateTime" TEXT DEFAULT (datetime('now', 'localtime')),
    "iRemark" TEXT
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tInventoryInfo", '2');

-- ----------------------------
--  Records of tInventoryInfo
-- ----------------------------
BEGIN;
INSERT INTO "tInventoryInfo" VALUES (1, 'commodity00001', '箱,包', '12,30', 'gcx', '', '');
INSERT INTO "tInventoryInfo" VALUES (2, 'commodity00002', '箱,袋', '20,15', 'gcx', '2016-11-08 14:39:59', null);
COMMIT;

-- ----------------------------
--  Table structure for tOrderInfo
-- ----------------------------
DROP TABLE IF EXISTS "tOrderInfo";
CREATE TABLE "tOrderInfo" (
    "orId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "orOrderNo" text NOT NULL,
    "orTotalPrice" REAL,
    "orWarehouseNo" text,
    "orSalesmanNo" text,
    "orSalesman" text,
    "orBusinessmanNo" text,
    "orBusinessman" TEXT,
    "orSaleType" integer,
    "orSettlementType" integer,
    "orState" integer,
    "orCreateTime" TEXT DEFAULT (datetime('now', 'localtime')),
    "orRemark" TEXT
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tOrderInfo", '1');

-- ----------------------------
--  Records of tOrderInfo
-- ----------------------------
BEGIN;
INSERT INTO "tOrderInfo" VALUES (1, 2016010100001, 1315.0, 'CK001', 'gcx', 'gcx', 'JSJ001', '佳乐家001', 0, 0, 0, '', '');
COMMIT;

-- ----------------------------
--  Table structure for tReturnInfo
-- ----------------------------
DROP TABLE IF EXISTS "tReturnInfo";
CREATE TABLE "tReturnInfo" (
    "rId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "rOrderNo" text,
    "rNewOrderNo" text,
    "tType" integer,
    "rBusinessmanNo" text,
    "rBusinessman" text,
    "rCreateUserNo" text,
    "rCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "rRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tReturnInfo", '1');

-- ----------------------------
--  Records of tReturnInfo
-- ----------------------------
BEGIN;
INSERT INTO "tReturnInfo" VALUES (1, 1, 1, 1, 1, 1, 1, 1, '');
COMMIT;

-- ----------------------------
--  Table structure for tSaleInfo
-- ----------------------------
DROP TABLE IF EXISTS "tSaleInfo";
CREATE TABLE "tSaleInfo" (
    "sId" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
    "sOrderNo" text NOT NULL,
    "sCoNo" text NOT NULL,
    "sName" text NOT NULL,
    "sCategory" text,
    "sUnit" text,
    "sPrice" text,
    "sCount" text,
    "sWarehouseNo" text,
    "sWarehouseName" text,
    "sSalesmanNo" text,
    "sSalesman" text,
    "sBusinessmanNo" text,
    "sBusinessman" text,
    "sSaleType" integer,
    "sSettlementType" integer,
    "sPromotionType" integer,
    "sCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "sState" integer,
    "sRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tSaleInfo", '5');

-- ----------------------------
--  Records of tSaleInfo
-- ----------------------------
BEGIN;
INSERT INTO "tSaleInfo" VALUES (1, 2016010100001, 'commodity00001', '金锣王10*50g', '食品,金锣,金锣王10*50', '箱,包', '450.00,9.00', '2,10', 'CK001 ', '仓库001', 'gcx', '测试业务员01', 'JSJ001', '佳乐家001', 0, 0, 0, '2016-11-08 10:05:28', 1, '备注信息01_00');
INSERT INTO "tSaleInfo" VALUES (2, 2016010100001, 'commodity00002', '旺旺雪饼10*15g', '食品,旺旺,旺旺雪饼10*15g', '箱,袋', '100.00,5.00', '3,5', 'CK001 ', '仓库001', 'gcx', '测试业务员01', 'JLJ001', '佳乐家001', 0, 0, 0, '2016-11-08 10:05:28', 1, '备注信息01_01');
COMMIT;

-- ----------------------------
--  Table structure for tUserInfo
-- ----------------------------
DROP TABLE IF EXISTS "tUserInfo";
CREATE TABLE "tUserInfo" (
    "uId" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "uUserNo" text,
    "uUserName" text,
    "uType" integer,
    "uPhone" text,
    "uAddr" text,
    "uWarehouseNo" text,
    "uCreateTime" text DEFAULT (datetime('now', 'localtime')),
    "uRemark" text
);
INSERT INTO "main".sqlite_sequence (name, seq) VALUES ("tUserInfo", '2');

-- ----------------------------
--  Records of tUserInfo
-- ----------------------------
BEGIN;
INSERT INTO "tUserInfo" VALUES (1, 'gcx', 'gcx', 1, 13866668888, '', 'CK001', '', '');
INSERT INTO "tUserInfo" VALUES (2, 'JSJ001', '佳乐家001', 2, null, null, null, '2016-11-08 14:34:38', null);
COMMIT;

PRAGMA foreign_keys = true;
